Mailing List

The Mailing List tab lets you make basic settings of the mailing list. The tab consists of the Mailing List and Database sections.

Figure. Mailing list level management: Mailing list tab.

Mailing List Section

Field

Description

Alias

A unique identifier for the account within the domain.

Description

A short descriptive text for the account.

Owner

The email address of the mailing list owner - multiple addresses can be specified here, separated by semicolons.

The account owner has special rights to this account.

You can use the '...' button open Select Accounts.

Source

A dropdown box allowing to quickly add a pre-defined set of members:

  • Members from Text file: Allows you to specify, or create, a simple text file containing email addresses of members. Each address is to be specified on a single line of the file.

  • Members from ODBC: Select this option to have IceWarp Server interrogate a database for list members.
    If you choose this option you will need to supply the SQL that IceWarp Server should use to extract addresses and variables from the database. See the next section for more information.

Note: The commands chosen at the Allowed Commands section (Management > List Servers > {list server}, see List Server), e.g.: Join (Subscribe), Leave (Unsubscribe), etc. are not available when this option is selected.

  • All current Domain Users: Messages will be sent to all users defined within this domain.

  • All System Users: Messages will be sent to all users defined in all domains within this IceWarp Server

  • All System Domain Administrators: Messages will be sent to all domain administrators within this IceWarp Server.

  • All System Administrators: Messages will be sent to all system administrators within this IceWarp Server.

List file

A simple text file containing all members of the group, one per line.

Database section

Field

Description

SQL statements

If you want to choose the Members from ODBC option (in the previous section), you need to supply the SQL that IceWarp Server should use to extract information from the database.

For example:

SELECT <YourData> FROM <YourTable> WHERE <YourCriteria>

  • <YourData> should specify which columns you need data extracted from.

  • <YourTable> should specify the table containing your data.

  • <YourCriteria> should specify any criteria you need to apply to your data.

Note: Variable values can be stored within the database and extracted within this SQL to create personalized messages. However, you need to comply with the following conditions:

The first field returned must be the email address.

The second field returned (if at all) must be the member Rights or blank.

Subsequent fields can be any variable values you wish to use.

If you also wish to use the Remove dead emails option in the Options tab, you will need to specify a second SQL statement here which IceWarp Server will use to delete addresses as required. The %s system variable should be used to specify the email address.

Example:

DELETE FROM <YourTable> WHERE <YourEmailField> = '%s'

  • <YourEmailField> should specify the column containing the email address of the member.

The two statements should be separated by a single line with a semicolon.

Example:

SELECT <YourData> FROM <YourTable> WHERE <YourCriteria>

;

DELETE FROM <YourTable> WHERE <YourEmailField> = '%s'

If your SQL is particularly long, you can specify it within a simple text file and enter the fully qualified filename in this area. IceWarp Serverr will recognize this as a file name and read it to collect the SQL.

Test SQL query

Performs an SQL state command to see if everything has been set up properly.

ODBC settings

Sets the ODBC source for the database connection.